/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : localhost
 Source Database       : test_ods

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : utf-8

 Date: 10/15/2019 17:23:31 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `dm_m_sales_tmp`
-- ----------------------------
DROP TABLE IF EXISTS `dm_m_sales_tmp`;
CREATE TABLE `dm_m_sales_tmp` (
  `id` varchar(50) COLLATE utf8_bin NOT NULL,
  `insertdate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `oms_order`
-- ----------------------------
DROP TABLE IF EXISTS `oms_order`;
CREATE TABLE `oms_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `trade_id` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '交易号',
  `platform_id` bigint(20) DEFAULT NULL COMMENT '平台ID',
  `platform_code` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '平台类型',
  `order_type` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '订单类型，数据字典ID',
  `store_id` bigint(20) DEFAULT NULL COMMENT '店铺ID',
  `store_code` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '店铺编码',
  `store_name` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '店铺名称',
  `trans_date` datetime DEFAULT '2000-01-01 00:00:00' COMMENT '交易日期',
  `pay_date` datetime DEFAULT NULL COMMENT '付款日期',
  `convert_date` datetime DEFAULT NULL COMMENT '转换日期',
  `buyer_message` varchar(1024) COLLATE utf8_bin DEFAULT NULL COMMENT '买家留言',
  `buyer_email` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '买家邮箱',
  `buyer_nick` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '买家昵称',
  `buyer_account` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '买家账号',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `price` decimal(20,5) DEFAULT '0.00000' COMMENT '价格',
  `payment` decimal(20,5) DEFAULT '0.00000' COMMENT '支付金额',
  `promotion` decimal(10,5) DEFAULT NULL COMMENT '促销金额',
  `is_manual` char(1) COLLATE utf8_bin DEFAULT '0' COMMENT '手工订单',
  `oms_order_status` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'oms中订单状态',
  `quantity` int(11) DEFAULT NULL COMMENT '商品总数量',
  `note` varchar(4172) COLLATE utf8_bin DEFAULT NULL COMMENT '内部便签',
  `audit_person` varchar(45) COLLATE utf8_bin DEFAULT NULL COMMENT '审核人',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `is_locked` char(255) COLLATE utf8_bin DEFAULT '0' COMMENT '是否锁定',
  `locker` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '锁定人',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `modified` datetime DEFAULT NULL COMMENT '修改时间',
  `creater` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
  `modifier` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
  `audit_status` varchar(20) COLLATE utf8_bin DEFAULT '0',
  `delivery_status` varchar(20) COLLATE utf8_bin DEFAULT '0',
  `delivery_date` datetime DEFAULT NULL,
  `is_intercept` varchar(2) COLLATE utf8_bin DEFAULT '0',
  `is_sendsms` varchar(2) COLLATE utf8_bin DEFAULT '0',
  `address` varchar(500) COLLATE utf8_bin DEFAULT NULL,
  `full_address` varchar(500) COLLATE utf8_bin DEFAULT NULL,
  `create_person` varchar(45) COLLATE utf8_bin DEFAULT NULL,
  `consignee` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `mobile` varchar(45) COLLATE utf8_bin DEFAULT NULL,
  `express_no` varchar(45) COLLATE utf8_bin DEFAULT NULL,
  `change_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'timestamp',
  `last_update` datetime NOT NULL COMMENT 'ods_统一时间戳',
  `insertdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '插入时间',
  PRIMARY KEY (`id`),
  KEY `idx_pay_date` (`pay_date`) USING BTREE,
  KEY `idx_last_update` (`last_update`) USING BTREE,
  KEY `idx_insertdate` (`insertdate`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='订单';

-- ----------------------------
--  Records of `oms_order`
-- ----------------------------
BEGIN;
INSERT INTO `oms_order` VALUES ('1', '100010110111', '1', 'taobao', '1', '2', 'tb_bencaoqj', '天猫本草旗舰店', '2019-10-08 16:50:00', '2019-10-08 16:50:03', '2019-10-08 16:50:09', null, 'test@126.com', 'test', 'test123', '1', '150.00000', '150.00000', null, '0', '1', '2', null, null, '2019-10-08 16:58:11', '0', null, '2019-10-08 16:58:16', null, null, null, '1', '0', null, '0', '0', null, null, null, null, null, null, '2019-10-08 16:59:18', '2019-10-08 16:59:18', '2019-10-09 12:00:55');
COMMIT;

-- ----------------------------
--  Table structure for `oms_order_item`
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_item`;
CREATE TABLE `oms_order_item` (
  `id` bigint(20) NOT NULL,
  `order_id` bigint(20) DEFAULT NULL COMMENT '订单ID',
  `first_cost` decimal(15,5) DEFAULT NULL COMMENT '一口价',
  `price_selling` decimal(15,5) DEFAULT NULL COMMENT '销售价',
  `discount_amount` decimal(15,5) DEFAULT NULL COMMENT '折扣数额',
  `amount_actual` decimal(20,5) DEFAULT NULL COMMENT '实付金额',
  `amount` decimal(15,5) DEFAULT NULL COMMENT '总金额',
  `discount_desc` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL COMMENT '数量',
  `is_deleted` char(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否行消',
  `is_out_of_stock` char(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否缺货',
  `product_name` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '本地商品名称',
  `product_code` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '本地商品货号',
  `bar_code` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '本地条形码',
  `is_virtual` char(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否虚拟商品',
  `is_pre_sale` char(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否预售商品',
  `is_gift` char(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否赠品',
  `promotion_code` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '活动编号',
  `brand_id` int(11) DEFAULT NULL COMMENT '品牌id',
  `brand_name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '品牌名称',
  `status` char(20) COLLATE utf8_bin DEFAULT NULL COMMENT '状态',
  `change_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'ʱ',
  `last_update` datetime NOT NULL COMMENT 'ods_统一时间戳',
  `insertdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '插入时间',
  PRIMARY KEY (`id`),
  KEY `fk_fk_order_detail` (`order_id`),
  KEY `idx_last_update` (`last_update`) USING BTREE,
  KEY `idx_insertdate` (`insertdate`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT COMMENT='订单_明细';

-- ----------------------------
--  Records of `oms_order_item`
-- ----------------------------
BEGIN;
INSERT INTO `oms_order_item` VALUES ('1', '1', '200.00000', '100.00000', '0.00000', '100.00000', '100.00000', null, '1', null, null, '胎菊', 'DJ0001', 'DJ000101', null, null, null, null, '1', '本草', '1', '2019-10-08 17:19:07', '2019-10-08 17:19:07', '2019-10-09 12:00:55'), ('2', '1', '500.00000', '360.00000', '20.00000', '340.00000', '360.00000', null, '2', null, null, '雪菊', 'DJ0002', 'DJ000201', null, null, null, null, '1', '本草', '1', '2019-10-08 17:19:18', '2019-10-08 17:19:18', '2019-10-09 12:00:55');
COMMIT;

-- ----------------------------
--  Table structure for `sys_brand_info`
-- ----------------------------
DROP TABLE IF EXISTS `sys_brand_info`;
CREATE TABLE `sys_brand_info` (
  `id` bigint(20) NOT NULL,
  `brand_code` varchar(20) DEFAULT NULL COMMENT '品牌代码',
  `brand_name` varchar(100) DEFAULT NULL COMMENT '品牌名称',
  `short_name` varchar(100) DEFAULT NULL,
  `run_prop` char(1) DEFAULT NULL,
  `run_status` char(1) DEFAULT NULL,
  `status` char(1) DEFAULT NULL COMMENT '状态',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `removed` datetime DEFAULT NULL,
  `creater` int(11) DEFAULT NULL,
  `modifier` int(11) DEFAULT NULL,
  `remover` int(11) DEFAULT NULL,
  `sort` varchar(10) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL COMMENT '最新更新时间',
  `insertdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sys_brand_info`
-- ----------------------------
BEGIN;
INSERT INTO `sys_brand_info` VALUES ('1', 'bencao', '本草', '', '1', '3', '1', '2015-01-26 19:49:40', '2019-08-29 21:08:19', null, '1', null, null, '017', '2019-08-29 21:08:19', '2019-10-08 15:41:45'), ('2', 'shennong', '神农', '', '1', '2', '1', '2015-01-26 19:49:40', '2019-08-29 21:00:00', null, '1', null, null, '986', '2019-08-29 21:00:00', '2019-10-08 15:42:49');
COMMIT;

-- ----------------------------
--  Table structure for `sys_category`
-- ----------------------------
DROP TABLE IF EXISTS `sys_category`;
CREATE TABLE `sys_category` (
  `id` int(11) DEFAULT NULL COMMENT '分类内码',
  `category_code` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `category_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父节点',
  `category_level` int(11) DEFAULT NULL COMMENT '等级',
  `leaf` char(1) CHARACTER SET utf8 DEFAULT NULL,
  `status` char(1) CHARACTER SET utf8 DEFAULT NULL,
  `last_update` datetime DEFAULT NULL COMMENT '业务系统最后修改日期',
  KEY `idx_id` (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sys_category`
-- ----------------------------
BEGIN;
INSERT INTO `sys_category` VALUES ('2', '1-', '赠品', '-1', '0', '0', '1', '2017-04-13 16:32:57'), ('1', '0-', '正常商品', '-1', '0', '0', '1', '2015-09-08 17:00:00'), ('8', '0-6-7-8', '菊花', '7', '3', '1', '1', '2015-01-27 02:27:02'), ('7', '0-6-7', '菊科', '6', '2', '0', '1', '2018-09-18 14:30:01'), ('6', '0-6', '草本', '1', '1', '0', '1', '2015-01-27 02:27:02'), ('4', '4-', '包装', '-1', '0', '0', '1', '2015-01-27 02:27:02'), ('3', '3-', '生产物料', '-1', '0', '0', '1', '2017-07-31 18:49:44');
COMMIT;

-- ----------------------------
--  Table structure for `sys_platform`
-- ----------------------------
DROP TABLE IF EXISTS `sys_platform`;
CREATE TABLE `sys_platform` (
  `platform_id` int(11) NOT NULL COMMENT '平台内码',
  `platform_code` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `platform_name` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  `status` char(1) COLLATE utf8_bin DEFAULT NULL,
  `last_update` datetime DEFAULT NULL COMMENT '业务系统最后修改日期',
  KEY `AK_Key_1` (`platform_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sys_platform`
-- ----------------------------
BEGIN;
INSERT INTO `sys_platform` VALUES ('1', 'taobao', '淘宝平台', '1', '2019-10-08 15:31:50'), ('2', 'dangdang', '当当平台', '1', '2019-10-08 15:32:22');
COMMIT;

-- ----------------------------
--  Table structure for `sys_product`
-- ----------------------------
DROP TABLE IF EXISTS `sys_product`;
CREATE TABLE `sys_product` (
  `id` varchar(32) NOT NULL COMMENT 'id',
  `product_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '货号',
  `name` varchar(100) DEFAULT NULL COMMENT 'name',
  `category_id` bigint(20) DEFAULT NULL,
  `category_code` varchar(50) DEFAULT NULL COMMENT '类目',
  `category_name` varchar(100) DEFAULT NULL,
  `brand_id` bigint(20) DEFAULT NULL COMMENT '品牌',
  `brand_name` varchar(100) DEFAULT NULL,
  `picture_url` varchar(255) DEFAULT NULL COMMENT '商品图片',
  `unit_id` varchar(32) DEFAULT NULL COMMENT '计量单位',
  `cost_price` decimal(10,4) DEFAULT NULL COMMENT '成本价',
  `orignial_price` decimal(10,4) DEFAULT NULL COMMENT '吊牌价',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `creater` bigint(20) DEFAULT NULL COMMENT '创建人',
  `creater_name` varchar(255) DEFAULT NULL COMMENT '创建人姓名',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `modifier` bigint(20) DEFAULT NULL COMMENT '修改人',
  `modifier_name` varchar(255) DEFAULT NULL COMMENT '修改人姓名',
  `modified` datetime DEFAULT NULL COMMENT '修改时间',
  `remover` bigint(20) DEFAULT NULL COMMENT '删除人',
  `remover_name` varchar(255) DEFAULT NULL COMMENT '删除人姓名',
  `removed` datetime DEFAULT NULL COMMENT '删除时间',
  `keyword_name` varchar(100) DEFAULT NULL,
  `unit_name` varchar(100) DEFAULT NULL,
  `last_update` datetime NOT NULL COMMENT 'ods_统一时间戳',
  `insertdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'dw????',
  PRIMARY KEY (`id`),
  KEY `last_update` (`last_update`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品资料';

-- ----------------------------
--  Records of `sys_product`
-- ----------------------------
BEGIN;
INSERT INTO `sys_product` VALUES ('1', 'DJ0001', '胎菊', '8', '0-6-7-8', '菊花', '1', '本草', null, null, null, null, null, '1', null, '2019-10-08 16:15:40', null, null, null, null, null, null, null, null, '2019-10-08 16:15:29', '2019-10-08 16:15:43'), ('2', 'DJ0002', '雪菊', '8', '0-6-7-8', '菊花', '1', '本草', null, null, null, null, null, '1', null, '2019-10-08 16:15:40', null, null, null, null, null, null, null, null, '2019-10-08 16:15:29', '2019-10-08 16:15:43');
COMMIT;

-- ----------------------------
--  Table structure for `sys_product_sku`
-- ----------------------------
DROP TABLE IF EXISTS `sys_product_sku`;
CREATE TABLE `sys_product_sku` (
  `id` varchar(32) NOT NULL COMMENT 'id',
  `bar_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `product_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '货号',
  `spec_code` varchar(50) DEFAULT NULL COMMENT '规格代码',
  `spec_name` varchar(100) DEFAULT NULL,
  `status` int(1) DEFAULT NULL COMMENT '状态',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `creater` bigint(20) DEFAULT NULL COMMENT '创建人',
  `creater_name` varchar(255) DEFAULT NULL COMMENT '创建人姓名',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `modifier` bigint(20) DEFAULT NULL COMMENT '修改人',
  `modifier_name` varchar(255) DEFAULT NULL COMMENT '修改人姓名',
  `modified` datetime DEFAULT NULL COMMENT '修改时间',
  `remover` bigint(20) DEFAULT NULL COMMENT '删除人',
  `remover_name` varchar(255) DEFAULT NULL COMMENT '删除人姓名',
  `removed` datetime DEFAULT NULL COMMENT '删除时间',
  `no_tax_cost_price` decimal(20,6) DEFAULT NULL COMMENT '成本价',
  `last_update` datetime NOT NULL COMMENT 'ods_统一时间戳',
  `insertdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'dw????',
  PRIMARY KEY (`id`),
  KEY `last_update` (`last_update`),
  KEY `product_code` (`product_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='sku';

-- ----------------------------
--  Records of `sys_product_sku`
-- ----------------------------
BEGIN;
INSERT INTO `sys_product_sku` VALUES ('1', 'DJ000101', 'DJ0001', '1', '杭白80g', '1', null, null, null, '2019-10-08 16:23:04', null, null, null, null, null, null, '50.000000', '2019-10-13 16:22:33', '2019-10-14 10:11:59'), ('2', 'DJ000102', 'DJ0001', '2', '杭白160g', '1', null, null, null, '2019-10-08 16:23:04', null, null, null, null, null, null, '90.000000', '2019-10-13 16:22:33', '2019-10-14 10:12:12'), ('3', 'DJ000201', 'DJ0002', '3', '顶级80g', '1', null, null, null, '2019-10-08 16:23:04', null, null, null, null, null, null, '100.000000', '2019-10-13 16:22:33', '2019-10-14 10:12:19'), ('4', 'DJ000202', 'DJ0002', '4', '特级160g', '1', null, null, null, '2019-10-08 16:23:04', null, null, null, null, null, null, '80.000000', '2019-10-13 16:22:33', '2019-10-14 10:12:24');
COMMIT;

-- ----------------------------
--  Table structure for `sys_store_info`
-- ----------------------------
DROP TABLE IF EXISTS `sys_store_info`;
CREATE TABLE `sys_store_info` (
  `id` bigint(20) NOT NULL,
  `store_code` varchar(50) DEFAULT NULL COMMENT '店铺代码',
  `store_name` varchar(100) DEFAULT NULL COMMENT '店铺名称',
  `province_id` bigint(20) DEFAULT NULL COMMENT '省份ID',
  `city_id` bigint(20) DEFAULT NULL COMMENT '城市ID',
  `district_id` bigint(20) DEFAULT NULL COMMENT '地区ID',
  `address` varchar(100) DEFAULT NULL COMMENT '地址',
  `zip` varchar(6) DEFAULT NULL COMMENT '邮编',
  `contacter` varchar(20) DEFAULT NULL COMMENT '联系人',
  `mobile` varchar(11) DEFAULT NULL COMMENT '手机号',
  `telephone` varchar(20) DEFAULT NULL COMMENT '固话',
  `fax` varchar(20) DEFAULT NULL COMMENT '传真',
  `open_date` datetime DEFAULT NULL COMMENT '开始时间',
  `close_date` datetime DEFAULT NULL COMMENT '关闭时间',
  `source_type` bigint(20) DEFAULT NULL COMMENT '平台类型',
  `source_code` varchar(20) DEFAULT NULL,
  `store_type` varchar(20) DEFAULT NULL COMMENT '店铺类型',
  `is_ahead_update` char(1) DEFAULT NULL COMMENT '是否提前更新',
  `is_flagship_store` int(1) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` char(1) DEFAULT NULL COMMENT '状态',
  `created` datetime NOT NULL COMMENT '创建时间',
  `modified` datetime DEFAULT NULL COMMENT '修改时间',
  `removed` datetime DEFAULT NULL COMMENT '删除时间',
  `creater` int(11) NOT NULL COMMENT '创建者',
  `modifier` int(11) DEFAULT NULL COMMENT '修改者',
  `remover` int(11) DEFAULT NULL COMMENT '删除者',
  `company` varchar(255) DEFAULT NULL COMMENT '所属公司（部门）',
  `turn` int(11) DEFAULT NULL,
  `main_part` varchar(255) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL COMMENT '最新更新时间',
  `insertdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sys_store_info`
-- ----------------------------
BEGIN;
INSERT INTO `sys_store_info` VALUES ('1', 'dd_shennongqj', '当当神农直营店', '1', null, null, '', '', '', null, '', '', '2014-11-10 18:20:39', null, '2', 'dangdang', 'DIRECT_SALE', '0', '0', '7246AE52-4A71-4AEF-B1FA-A1A500C3F98F', '0', '2014-11-10 18:20:39', '2018-08-14 10:57:09', null, '1', '1', null, '', '41', '1', '2018-08-14 10:57:09', '2019-10-08 15:52:39'), ('2', 'tb_bencaoqj', '天猫本草旗舰店', '1', null, null, '', '', '', null, '', '', '2014-11-10 18:20:39', null, '1', 'taobao', 'DIRECT_SALE', '0', '1', '74DF3DA1-D3B3-41EA-8D87-A1AB01447B22', '0', '2014-11-10 18:20:39', '2016-01-26 13:13:58', null, '1', '1', null, '', '42', null, '2016-01-26 13:13:58', '2019-10-08 15:52:34');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
